from django.db import models

from django.contrib.auth.models import AbstractUser
# Create your models here.
from meiduo_mall.utils.models import BaseModel


class User(AbstractUser):
    '''自定义用户模型类
    新增mobile字段
    y用户和默认地址:一对一的关联关系,一个用户只有一个默认地址,一个默认地址只属于一个用户
    '''
    mobile = models.CharField(max_length=11,unique=True,verbose_name="手机号")
    # 用户中心新增邮箱字段
    email_active = models.BooleanField(default=False, verbose_name='邮箱状态')
    # Day7.默认地址
    default_address = models.ForeignKey('Address', related_name='users', null=True, blank=True, on_delete=models.SET_NULL, verbose_name='默认地址')

    class Meta:
        db_table = "tb_users" # 自定义表名,如果不定义,默认是子应用_类名小写(users_user)
        verbose_name = "用户表"
        verbose_name_plural = verbose_name

    def __str__(self):
        return self.username # 使用用户名来调试模型类的信息


class Address(BaseModel):
    """用户地址"""
    # 查询当前用户的所有地址:user.address_set 或者 user.addresses(如果有了
    # related_name,默认的查询方式作废)
    # 查询地址属于的用户:address.user
    user = models.ForeignKey(User, on_delete=models.CASCADE, related_name='addresses', verbose_name='用户')
    title = models.CharField(max_length=20, verbose_name='地址标题')
    receiver = models.CharField(max_length=20, verbose_name='收货人')
    province = models.ForeignKey('areas.Area', on_delete=models.PROTECT, related_name='province_addresses', verbose_name='省')
    city = models.ForeignKey('areas.Area', on_delete=models.PROTECT, related_name='city_addresses', verbose_name='市')
    district = models.ForeignKey('areas.Area', on_delete=models.PROTECT, related_name='district_addresses', verbose_name='区')
    place = models.CharField(max_length=50, verbose_name='地址')
    mobile = models.CharField(max_length=11, verbose_name='手机')
    tel = models.CharField(max_length=20, null=True, blank=True, default='', verbose_name='固定电话')
    email = models.CharField(max_length=30, null=True, blank=True, default='', verbose_name='电子邮箱')
    is_deleted = models.BooleanField(default=False, verbose_name='逻辑删除')

    class Meta:
        db_table = 'tb_address'
        verbose_name = '用户地址'
        verbose_name_plural = verbose_name
        ordering = ['-update_time'] # 默认排序规则,最新修改的地址在最前面(倒叙)